package com.sy2.netshop.mapper;

import com.sy2.netshop.entity.Commodity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ComMapper {
    @Select("select * from commodity where PName like concat('%',#{pname},'%') limit #{m},5")
    List<Commodity> getComByPname(String pname, Integer m);
}
